CREATE TABLE [dbo].[PsJanMar]
(
[SecurityName/Description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AssetID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FundID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocalCurrency] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TransactionType] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Shares/Par] [float] NULL,
[Price(Base)] [float] NULL,
[NetAmount(Base)] [float] NULL,
[IDCostBase-BuyLot] [float] NULL,
[TradeDate] [datetime] NULL,
[ContractualSettleDate] [datetime] NULL,
[SettlementCurrency] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SettlementLocation] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SettlementStatus] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Broker] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BrokerNumber] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SSCTradeID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SegregatedLot] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ClosingDate] [datetime] NULL,
[LastClosingDate] [datetime] NULL,
[FreetoDistributeDate] [datetime] NULL,
[ContributingID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ClosingPrice] [float] NULL,
[Investor] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BaseCurrencyCode] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CancelTradeID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OriginalTradeID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountNumber] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountNumber-BuyLot] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CancelPostDate] [datetime] NULL,
[CancelReasonCode] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CancelReportDate] [datetime] NULL
) ON [PRIMARY]
GO
